import numpy as np
import pandas as pd

dataExcel = pd.read_excel('葡萄酒分数数据1.0.xlsx')

res = []
for k in range(10):
    arr = []
    for i in range(27):
        j = i * 12
        left = 0 + j
        right = 10 + j
        # print(dataExcel[f'品酒员{k+1}号'][left:right].sum())
        arr.append(dataExcel[f'品酒员{k+1}号'][left:right].sum())
    res.append(arr)
res = np.array(res).T

df = pd.DataFrame(res)

df.to_excel('处理后评分数据.xlsx')
